SyStaffGroup 
Logical Entity Name  SyStaffGroup 
Default Table Name  SyStaffGroup 
Physical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

SyStaffGroup Columns 
ColumnName  Domain  Datatype  NULL  Definition 
Code    char(8)  NO 
 
Descrip    varchar(40)  NO 
 
active    bit  NO 
 
ModFlag    char(1)  NO 
 
SystemCode    bit  NO 
 
UserID    int  NO 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  YES 
 
ts    timestamp  NO 
 
SyStaffGroupID(PK)    int  NO 
 
RequiredForEnroll    bit  NO 
 
AdvisorModule(FK)    char(8)  YES 
 
OverrideLeadDup    bit  NO 
 
GroupType    char(4)  YES 
 
AllowDropLDAAttendChange    bit  NO 
 
CampusLinkAmbassadorUse    bit  NO 
 
PositivePayUse    bit  NO 
 
CrmSuppressFlag    bit  NO 
 

SyStaffGroup Primary and Unique Keys 
Key Name  Key Type  Keys 
SyStaffGroup_SyStaffGroupID_U_C_IDX  PrimaryKey  SyStaffGroupID 

SyStaffGroup Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
SyModule  Non-Identifying  Zero or One to Zero or More  FK_SyStaffGroup_AdvisorModule_SyModule_Code      AdvisorModule  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 
cmActions  Non-Identifying  One To Zero or More  FK_cmActions_SyStaffGroupID_SyStaffGroup_SyStaffGroupID        NO  YES 
cmStaffGroupAccess  Non-Identifying  One To Zero or More  FK_cmStaffGroupAccess_SyStaffGroupID_SyStaffGroup_SyStaffGroupID        NO  YES 
FaCashPlanConfiguration  Non-Identifying  One To Zero or More  FK_FaCashPlanConfigurationPrintNotificationStaffGroupId_SyStaffGroupSyStaffGroupId        NO  YES 
FaCashPlanWorkflowAudit  Non-Identifying  One To Zero or More  FK_FaCashPlanWorkflowAuditCurrentAssignedStaffGroupId_SyStaffGroupStaffGroupId        NO  YES 
FaCashPlanWorkflowAudit  Non-Identifying  One To Zero or More  FK_FaCashPlanWorkflowAuditPreviousAssignedStaffGroupId_SyStaffGroupStaffGroupId        NO  YES 
FaPromNotePrintAssignment  Non-Identifying  One To Zero or More  FK_FaPromNotePrintAssignmentAssignedStaffGroupId_SyStaffGroupSyStaffGroupId        NO  YES 
FaPromNotePrintAudit  Non-Identifying  One To Zero or More  FK_FaPromNotePrintAuditCurrentAssignedStaffGroupId_SyStaffGroupSyStaffGroupId        NO  YES 
FaPromNotePrintAudit  Non-Identifying  One To Zero or More  FK_FaPromNotePrintAuditPreviousAssignedStaffGroupId_SyStaffGroupSyStaffGroupId        NO  YES 
FaStudentAidCashPlanAssignment  Non-Identifying  One To Zero or More  FK_FaStudentAidCashPlanAssignment_AssignedStaffGroupId_SyStaffGroup_StaffGroupId        NO  YES 
SaACHConfig  Non-Identifying  One To Zero or More  FK_SaACHConfig_SyStaffGroupID_SyStaffGroup_SyStaffGroupID        NO  YES 
SaBillCodeStaffGroupPost  Non-Identifying  One To Zero or More  FK_SaBillCodeStaffGroupPost_SyStaffGroupId_SyStaffGroup_SyStaffGroupId        NO  YES 
SaDisbReceiptNotification  Non-Identifying  One To Zero or More  Fk_SaDisbReceiptNotification_SyStaffGroupID_SyStaffGroup_SyStaffGroupID        NO  YES 
SaPWDAssignment  Non-Identifying  One To Zero or More  FK_SaPWDAssignmentAssignedStaffGroupID_SyStaffGroupSyStaffGroupID        NO  YES 
SaPWDNotificationConfiguration  Non-Identifying  One To Zero or More  FK_SaPWDNotificationConfigurationNotificationStaffGroupID_SyStaffGroupSyStaffGroupID        NO  YES 
SaPWDRoutingTemplate  Non-Identifying  One To Zero or More  FK_SaPWDRoutingTemplateAssignedStaffGroupID_SyStaffGroupSyStaffGroupID        NO  YES 
SaRefundCalculationAssignment  Non-Identifying  One To Zero or More  FK_SaRefundCalculationAssignmentAssignedStaffGroupId_SyStaffGroupSyStaffGroupId        NO  YES 
SaRefundCalculationRoutingTemplate  Non-Identifying  One To Zero or More  FK_SaRefundCalculationRoutingTemplateAssignedStaffGroupID_SyStaffGroupSyStaffGroupID        NO  YES 
SaRefundCalculationWorkflowAudit  Non-Identifying  One To Zero or More  FK_SaRefundCalculationWorkflowAuditCurrentAssignedStaffGroupId_SyStaffGroupSyStaffGroupId        NO  YES 
SaRefundCalculationWorkflowAudit  Non-Identifying  One To Zero or More  FK_SaRefundCalculationWorkflowAuditPreviousAssignedStaffGroupId_SyStaffGroupSyStaffGroupId        NO  YES 
SaReturnOfT4Assignment  Non-Identifying  One To Zero or More  FK_SaReturnOfT4AssignmentAssignedStaffGroupId_SyStaffGroupSyStaffGroupId        NO  YES 
SaReturnOfT4PWDWorkflowAudit  Non-Identifying  One To Zero or More  FK_SaReturnOfT4PWDWorkflowAuditCurrentAssignedStaffGroupID_SyStaffGroupSyStaffGroupID        NO  YES 
SaReturnOfT4PWDWorkflowAudit  Non-Identifying  One To Zero or More  FK_SaReturnOfT4PWDWorkflowAuditPreviousAssignedStaffGroupID_SyStaffGroupSyStaffGroupID        NO  YES 
SaTransPendingChecks  Non-Identifying  One To Zero or More  Fk_SaTransPendingChecks_SyStaffGroupID_SyStaffGroup_SyStaffGroupID        NO  YES 
SyAdvisorCampusDefaults  Identifying  One To Zero or More  FK_SyAdvisorCampusDefaults_SyStaffGroupID_SyStaffGroup_SyStaffGroupID        NO  YES 
SYCTStaffGroup  Non-Identifying  One To Zero or More  FK_SYCTStaffGroup_SyStaffGroupID_SyStaffGroup_SyStaffGroupID        NO  YES 
SYFSStaffGroup  Non-Identifying  One To Zero or More  FK_SYFSStaffGroup_SyStaffGroupID_SyStaffGroup_SyStaffGroupID        NO  YES 
SySchoolStatusGridStaffGroup  Identifying  One To Zero or More  FK_SySchoolStatusGridStaffGroup_SyStaffGroupID_SyStaffGroup_SyStaffGroupID        NO  YES 
SySecurity  Non-Identifying  One To Zero or More  FK_SySecurity_SyStaffGroupID_SyStaffGroup_SyStaffGroupID        NO  YES 
SyServiceExceptionAssignment  Non-Identifying  One To Zero or More  FK_SyServiceExceptionAssign_AssignedStaffGroupId_SyStaffGroup_StaffGroupId        NO  YES 
SyServiceExceptionAssignment  Non-Identifying  One To Zero or More  FK_SyServiceExceptionAssign_ReviewByStaffGroupId_SyStaffGroup_StaffGroupId        NO  YES 
SyServiceExceptionAudit  Non-Identifying  One To Zero or More  FK_SyServiceExceptionAudit_CurrentAssignedStaffGroupId_SyStaffGroup_SyStaffGroupId        NO  YES 
SyServiceExceptionAudit  Non-Identifying  One To Zero or More  FK_SyServiceExceptionAudit_CurrentReviewStaffGroupId_SyStaffGroup_SyStaffGroupId        NO  YES 
SyServiceExceptionAudit  Non-Identifying  One To Zero or More  FK_SyServiceExceptionAudit_PreviousAssignedStaffGroupId_SyStaffGroup_SyStaffGroupId        NO  YES 
SyServiceExceptionAudit  Non-Identifying  One To Zero or More  FK_SyServiceExceptionAudit_PreviousReviewStaffGroupId_SyStaffGroup_SyStaffGroupId        NO  YES 
SyServiceExceptionCampusProperty  Non-Identifying  One To Zero or More  FK_SyServiceExceptionCampusProperty_ReviewByStaffGroupId_SyStaffGroup_StaffGroupId        NO  YES 
SyServiceExceptionDocumentReview  Non-Identifying  One To Zero or More  FK_SyServiceExceptionDocumentReviewReviewSyStaffGroupId_SyStaffGroupSyStaffGroupID        NO  YES 
SyServiceExceptionOverrideConfigurationTemplate  Non-Identifying  One To Zero or More  FK_SyServiceExceptionOverrideConfigurationTemplateAssignedStaffGroupId_SyStaffGroupSyStaffGroupId        NO  YES 
SyServiceExceptionSavedSearchAssignment  Non-Identifying  One To Zero or More  FK_SyServiceExceptionSavedSearchAssignmentAssignedStaffGroupId_SyStaffGroupSyStaffGroupId        NO  YES 
SyServiceExceptionTemplate  Non-Identifying  One To Zero or More  FK_SyServiceExceptionTemplateReviewByStaffGroupID_StaffGroupStaffGroupID        NO  YES 
SyServiceNotificationTemplateAssignment  Non-Identifying  One To Zero or More  FK_SyServiceNotificationTemplateAssignmentNotifyStaffGroupId_SyStaffGroupSyStaffGroupId        NO  YES 
SyServicePerformanceGoalsAssignment  Non-Identifying  One To Zero or More  FK_SyServicePerformanceGoalsAssignmentSyStaffGroupID_SyStaffGroupIDSyStaffGroupID        NO  YES 
SyServiceStaffGroupDelegation  Non-Identifying  One To Zero or More  FK_SyServiceStaffGroupDelegation_StaffGroupId_SyStaffGroup_SyStaffGroupId        NO  YES 
SyServiceStaffGroupHierarchy  Non-Identifying  One To Zero or More  FK_SyServiceStaffGroupHierarchy_StaffGroupId_SyStaffGroup_SyStaffGroupId        NO  YES 
SyServiceStaffGroupHierarchy  Non-Identifying  One To Zero or More  FK_SyServiceStaffGroupHierarchy_SyStaffGroupId_SyStaffGroup_SyStaffGroupID        NO  YES 
SyStaffByGroup  Non-Identifying  One To Zero or More  FK_SyStaffByGroup_syStaffGroupID_SyStaffGroup_SyStaffGroupID        NO  YES 
SyStaffGroupRefreshFreq  Non-Identifying  One To Zero or More  FK_SyStaffGroupRefreshFreq_SyStaffGroup        NO  YES 
SyStaffGroupTemplate  Non-Identifying  One To Zero or More  FK_SyStaffGroupTemplate_SyStaffGroupID_SyStaffGroup_SyStaffGroupID        NO  YES 
SyStatusGridStaffGroup  Identifying  One To Zero or More  FK_SyStatusGridStaffGroup_SyStaffGroupID_SyStaffGroup_SyStaffGroupID        NO  YES 
WorkspaceStaffGroup  Non-Identifying  One To Zero or More  FK_WorkSpaceStaffGroup_SyStaffGroupId_SyStaffGroup_SyStaffGroupId        NO  NO 

SyStaffGroup Check Constraints 
Check Constraint Name  CheckConstraint 

SyStaffGroup Storage 
STORAGE OPTION  STORAGE VALUE 
Filegroup  PRIMARY 
Text Image File Group   

SyStaffGroup Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.StaffGroup 
NO       
Physical (Microsoft SQL Server)
dbo.SyStaffGroup 
NO       

SyStaffGroup Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  Addresses_Affiliations 
Logical  Employers 
Logical  StudentEnrollment 
Logical  Tasks 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  System 

SyStaffGroup Data Movement Rules 
Name  Type  Rule Text/Value